BEGIN TRY
	CREATE DATABASE REAL_Source_Sample_V6
END TRY BEGIN CATCH END CATCH
GO
BEGIN TRY
	USE REAL_Source_Sample_V6;
	CREATE TABLE dbo.BN_Store_FULL(
		STORE_NUM numeric(5, 0) NOT NULL,
		ORDER_STATUS varchar(1) NULL,
		STORE_DESC varchar(100) NULL,
		MERCH_DIV_NUM numeric(3, 0) NULL,
		STATUS varchar(1) NULL,
		OPEN_DATE datetime NULL,
		CLOSE_DATE datetime NULL,
		DIVISION_NUM numeric(3, 0) NULL,
		DIVISION_DESC varchar(100) NULL,
		REGION_NUM numeric(5, 0) NULL,
		REGION_DESC varchar(100) NULL,
		DISTRICT_NUM numeric(5, 0) NULL,
		DISTRICT_DESC varchar(100) NULL,
		MARKET_AREA_NUM numeric(5, 0) NULL,
		MARKET_AREA_DESC varchar(100) NULL,
		MARKET_TYPE varchar(1) NULL,
		AD_AREA_NUM numeric(5, 0) NULL,
		AD_AREA_DESC varchar(100) NULL,
		CENTER_DESC varchar(100) NULL,
		CITY varchar(35) NULL,
		ZIP_CODE varchar(10) NULL,
		STATE varchar(2) NULL,
		MGR_NAME varchar(100) NULL,
		FRP_FLAG varchar(1) NULL,
		LTA_DAYS numeric(5, 0) NULL,
		LTA_SHIP_DAY numeric(5, 0) NULL,
		PI_INVENTORY_DATE datetime NULL,
		TYPE varchar(1) NULL,
		FLR_FLAG varchar(1) NULL,
		ADD_DTIME datetime NULL,
		UPD_DTIME datetime NULL,
		UPD_USER_ID varchar(8) NULL,
		REPLEN_TYPE varchar(1) NULL,
		STORE_PHONE varchar(15) NULL,
		SQUARE_FEET numeric(10, 0) NULL,
		ADDR_LINE1 varchar(80) NULL,
		ADDR_LINE2 varchar(80) NULL,
		CALLOUT_IND varchar(1) NULL,
		CLOSE_REASON_CODE varchar(1) NULL,
		COUNTY_NAME varchar(25) NULL,
		DEMOGRAPH_MKT_SEQ numeric(4, 0) NULL,
		FAX varchar(14) NULL,
		FIN_DIST_NUM numeric(3, 0) NULL,
		FIN_DIV_NUM numeric(3, 0) NULL,
		FIN_INVENTORY_DATE datetime NULL,
		FIXTURE_TYPE varchar(20) NULL,
		FRP_INVNTRY_DATE datetime NULL,
		GRAND_OPEN_DATE datetime NULL,
		LATITUDE numeric(11, 6) NULL,
		LINEAR_FT numeric(5, 0) NULL,
		LONGITUDE numeric(11, 6) NULL,
		MANUAL_ORDER_DATE datetime NULL,
		MARKET_LOCN_CODE varchar(1) NULL,
		MERCH_DIST_NUM numeric(3, 0) NULL,
		OFFICE_PHONE varchar(15) NULL,
		ON_HAND_UPD_DATE datetime NULL,
		OPEN_CODE varchar(1) NULL,
		PROJ_SALES_AMT numeric(9, 2) NULL,
		PROJECT_CODE varchar(7) NULL,
		PROTOTYPE_IND varchar(1) NULL,
		REMODEL_DATE datetime NULL,
		SALES_QTY numeric(9, 0) NULL,
		SAN_ID varchar(8) NULL,
		SIGN_COLOR varchar(30) NULL,
		TIME_CARD_CODE varchar(1) NULL,
		TRADE_CONVSN_NUM numeric(3, 0) NULL,
		VACATE_DATE datetime NULL,
		VOL_CLASS_CODE varchar(1) NULL,
		WAGE_PLAN_CODE varchar(2) NULL,
		ZIP_CODE_EXT varchar(4) NULL,
		PI_SCHEDULE_DATE datetime NULL,
		PI_MUSIC_INV_DATE datetime NULL,
		PI_MUSIC_SCHD_DATE datetime NULL,
		BN_ETL_Load_ID int NULL,
		STATUS_DESC varchar(255) NULL,
		DIVISION varchar(100) NULL,
		Logical_Date datetime NULL
	)
END TRY BEGIN CATCH END CATCH
GO